{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Farm Calculator","Graph - costs","Graph - youngstock vaccine","Graph - milking herd vaccine"],"not_rendered":{"charts":6,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Graph - costs","index":1,"reason":"not_a_worksheet"},{"sheet":"Graph - youngstock vaccine","index":2,"reason":"not_a_worksheet"},{"sheet":"Graph - milking herd vaccine","index":3,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Farm Calculator","index":0,"n_rows":93,"n_cols":8,"rows_kept":93,"cut":false,"hidden":false,"merged":[[27,1,27,5],[1,1,1,3],[62,1,62,4],[65,1,65,4],[24,1,24,4],[25,1,25,4],[63,1,63,4],[64,1,64,4]]}
[]
[null,"How much will farmers spend or save by vaccinating their dairy cattle against BTV-3?"]
[]
[]
[null,"Step 1. Input your data in the blue cells"]
[]
[null,"What is your average annual milk production per cow?",null,"  Insert the average volume in litres"]
[]
[null,"What do your current milk price?",null,"  Insert your latest milk price eg. £0.46 for 46ppl"]
[]
[null,"How many dairy cows are there in your milking herd?",null,"  Use the number of milking cows including any dry cows"]
[]
[null,"How many youngstock do you have?",null,"  Use the number of cattle less than 2 years old not milking"]
[]
[null,"What would it cost you to replace a dairy cow?",3000,"  Default £3000 is a suggested figure"]
[]
[null,"What would the value of your youngstock be?",1500,"  Default £1500 is a suggested figure for a young heifer"]
[]
[null,"What would the value of one of your calves be?",300,"  Default £300 is a suggested figure for a calf"]
[]
[null,"What is the BTV-3 vaccination cost per animal?",10,"  Please talk to your vet to get an up-to-date figure"]
[]
[null,"Step 2. Review your results",null,""]
[]
[null,"The tables below show the impact of BTV-3 infection in different scenarios, based on the numbers you provide in step 1. The scenarios represent mild infection (A) through to severe infection (D). AHDB has developed each scenario based on actual data from the UK and mainland Europe. "]
[null,"The calculator doesn't allow you to mix the scenarios - so the results won't be valid if you take productivity costs from Scenario A and add mortality costs from Scenario B etc. You need to follow the same scenario throughout."]
[]
[null,"Productivity costs - infected cattle will produce less milk"]
[null,"Scenario","Litres lost","Lost milk value","Total",null,"drop in herd yield","for period of time"]
[0.1,"A) Mild infection - 2% drop in herd yield for 3 months",{"$f":"($C$7*$C$11)*G30*H30","v":0},{"$f":"C30*$C$9","v":0},{"$f":"D30","v":0},null,0.02,{"$f":"3/12","v":0.25}]
[0.15,"B) Moderate infection - 4% drop in herd yield for 4 months",{"$f":"($C$7*$C$11)*G31*H31","v":0},{"$f":"C31*$C$9","v":0},{"$f":"D31","v":0},null,0.04,{"$f":"4/12","v":0.33333333333333331}]
[0.25,"C) Moderate to severe infection - 6% drop in herd yield for 5 months ",0,{"$f":"C32*$C$9","v":0},0,null,0.06,{"$f":"5/12","v":0.41666666666666669}]
[0.3,"D) Severe infection - 8% drop in herd yield for 6 months",0,{"$f":"C33*$C$9","v":0},0,null,0.08,{"$f":"6/12","v":0.5}]
[]
[null,"Mortality costs - the lost value from cattle that die"]
[null,"Scenario","Youngstock","Milking herd","Total"]
[0.01,"A) If 1% of infected animals die",{"$f":"($C$13*A30*A37)*$C$17","v":0},{"$f":"($C$11*A30*A37)*$C$15","v":0},{"$f":"SUM(C37:D37)","v":0}]
[2.5000000000000001E-2,"B) If 2.5% of infected animals die",{"$f":"($C$13*A31*A38)*$C$17","v":0},{"$f":"($C$11*A31*A38)*$C$15","v":0},{"$f":"SUM(C38:D38)","v":0}]
[0.04,"C) If 4% of infected animals die",0,{"$f":"($C$11*A32*A39)*$C$15","v":0},0]
[0.06,"D) If 6% of infected animals die",0,{"$f":"($C$11*A33*A40)*$C$15","v":0},0]
[]
[null,"Fertility costs - infected cattle can have reduced fertility"]
[null,"Scenario","Youngstock","Milking herd","Total"]
[0,"A) 0% reduction in calves from infected cattle",0,{"$f":"(($C$11*A30)*$C$19)*A44","v":0},{"$f":"D44","v":0}]
[0.15,"B) 15% reduction in calves from infected cattle",0,{"$f":"(($C$11*A31)*$C$19)*A45","v":0},{"$f":"D45","v":0}]
[0.3,"C) 30% reduction in calves from infected cattle",0,{"$f":"(($C$11*A32)*$C$19)*A46","v":0},0]
[0.5,"D) 50% reduction in calves from infected cattle",0,{"$f":"(($C$11*A33)*$C$19)*A47","v":0},0]
[]
[null,"Step 3. Understand the cost of vaccination"]
[]
[null,null,"Youngstock","Milking herd","Total"]
[null,"How much will it cost to vaccinate your cattle?",{"$f":"C13*C21","v":0},{"$f":"C11*C21","v":0},{"$f":"D52+C52","v":0}]
[]
[null,"How much will vaccinating your cattle save you? - we assume a 50% reduction in infections and 75% reduction in mortality."]
[]
[null,"Scenario","Youngstock","Milking herd","Total"]
[null,"Scenario A - Mild infection",{"$f":"(C37*$B$77)+(C44*$B$76)","v":0},{"$f":"(D37*$B$77)+(D44*$B$76)+(D30*$B$76)","v":0},{"$f":"D57+C57","v":0}]
[null,"Scenario B - Mild to moderate infection",{"$f":"(C38*$B$77)+(C45*$B$76)","v":0},{"$f":"(D38*$B$77)+(D45*$B$76)+(D31*$B$76)","v":0},{"$f":"D58+C58","v":0}]
[null,"Scenario C - Moderate to severe infection",{"$f":"(C39*$B$77)+(C46*$B$76)","v":0},{"$f":"(D39*$B$77)+(D46*$B$76)+(D32*$B$76)","v":0},0]
[null,"Scenario D - Severe infection",{"$f":"(C40*$B$77)+(C47*$B$76)","v":0},{"$f":"(D40*$B$77)+(D47*$B$76)+(D33*$B$76)","v":0},0]
[]
[]
[null,"1. Savings are calculated by accounting for the number of cattle you have identified, the cost of the vaccine and the effect of productivity, mortality and reduced fertility. For productivity we assume any milk production lost will be for the limited periods outlined, the calculator assumes that after this a cow will return to full production. The calculator does not include costs such as labour and consumables or costs for the disposal of dead stock. "]
[null,"2. The calculator does not assess the impact on other livestock on farm or breeding bulls, which should be high priority cattle for vaccination on farm due to their high value and the potential impact of BTV-3 on the bull's fertility.. "]
[null,"3. BTV-3 is an emerging disease and there is a high level on uncertainty around the fertility impacts of the disease including how severe clinical signs are in calves.  The fertility scenarios are very broad, reflecting this uncertainty. Scenario D with a 50% reduction is most likely to occur with an infected bull, but there are some farms with high levels of abortion/deformed calves which are purely related to infected cows."]
[null,"4. Results from this calculator are based on a series of assumptions and should be treated as a tool to aid decision-making on-farm. Actual impacts will vary depending on the specific outbreak of BTV-3. Always seek advice of your vet to fully assess the risks and the cost-benefits as part of your herd health planning. Please note that vaccination will reduce clinical signs and mortality, but it will not eliminate them altogether. "]
[null,"For more information and advice on Bluetongue please visit the AHDB website: "]
[null,"Bluetongue virus latest news | AHDB"]
[]
[]
[]
[]
[]
[]
["hidden data"]
["vaccination impact on infection",0.5,"set value which can not be changed",null,null,{"$f":"B77+B76","v":1.25},"vaccination impact on ingection + mortality"]
["vaccination impact on mortality",0.75,"set value which can not be changed"]
[]
[]
[]
[null,"Youngstock vaccination cost","Youngstock savings","Milking herd vaccination cost","Milking herd savings"]
[null,{"$f":"C52","v":0},{"$f":"C57","v":0},{"$f":"D52","v":0},{"$f":"D57","v":0}]
[null,{"$f":"C52","v":0},{"$f":"C58","v":0},{"$f":"D52","v":0},{"$f":"D58","v":0}]
[null,{"$f":"C52","v":0},{"$f":"C59","v":0},{"$f":"D52","v":0},0]
[null,{"$f":"C52","v":0},{"$f":"C60","v":0},{"$f":"D52","v":0},0]
[]
[]
[]
[null,"Productivity costs","Mortality costs","Fertility costs"]
["Scenario A - mild",{"$f":"E30","v":0},{"$f":"E37","v":0},{"$f":"D44","v":0}]
["Scenario B - mild to moderate",{"$f":"E31","v":0},{"$f":"E38","v":0},{"$f":"D45","v":0}]
["Scenario C - moderate to severe",{"$f":"E32","v":0},{"$f":"E39","v":0},{"$f":"D46","v":0}]
["Scenario D - severe",{"$f":"E33","v":0},{"$f":"E40","v":0},{"$f":"D47","v":0}]